CREATE TABLE [dbo].[devise]
(
[id_devise] [int] NOT NULL IDENTITY(1, 1),
[devise] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[cours] [decimal] (18, 0) NULL,
[sigle] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
ALTER TABLE [dbo].[devise] ADD 
CONSTRAINT [PK_devise] PRIMARY KEY CLUSTERED  ([id_devise]) ON [PRIMARY]
GO
